package cn.edu.ctbu.dp01.api;

import cn.edu.ctbu.dp01.constant.REnum;
import cn.edu.ctbu.dp01.dao.StudentRepository;
import cn.edu.ctbu.dp01.entity.Student;
import cn.edu.ctbu.dp01.exception.RException;
import cn.edu.ctbu.dp01.service.StudentService;
import cn.edu.ctbu.dp01.util.RUtil;
import cn.edu.ctbu.dp01.vo.QueryObj;
import cn.edu.ctbu.dp01.vo.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.*;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/api/student")
public class StudentApiController {

    @Autowired
    private StudentService studentService;
    @Autowired
    private StudentRepository studentRepository;

    @GetMapping("/list")
    public R<List<Student>> findAll() {

        List<Student> students = studentService.getAll();
        return RUtil.success(students);
    }

    @GetMapping("/{id}")
    public R<Student> findById(@PathVariable int id) {

        Student student = studentService.findById(id);
        return RUtil.success(student);
    }


    @PostMapping("/add")
    public R<Student> add(Student student) {

        return RUtil.success(studentService.add(student));

    }

    @PutMapping("/update")
    public R<Student> update(Student student) {

        return RUtil.success(studentService.update(student));

    }

    @DeleteMapping("/delete/{id}")
    public R delete(@PathVariable Integer id) {
        studentService.delete(id);
        return RUtil.success();

    }
    @GetMapping("/validateUser")
    public R validateSnoAndPassword(String sno,String password) throws Exception{

        return RUtil.success(studentService.validateUsernameAndPassword(sno,password));

    }

    @PostMapping("/getbypage")
    public R<Page<Student>> getByPage(@RequestBody QueryObj<Student> qObj) {
        //换id排倒序
        Sort sort  = Sort.by(Sort.Direction.DESC,"id");
        Integer pageIndex=0;
        Integer pageSize = 10;

        //分页查询
        if(qObj== null){
            //student为空就直接调用分页
            Pageable pageable = PageRequest.of(pageIndex,pageSize,sort);
            Page<Student> students = studentService.getAll(pageable);
            return RUtil.success(students.getContent(),students.getTotalElements());
        }else{
            //qObj不为空
            pageIndex= qObj.getPage()-1;
            pageSize = qObj.getLimit();

            //示例查询
            if(qObj.getData() instanceof Student){
                Student student = (Student) qObj.getData();
                Pageable pageable = PageRequest.of(pageIndex,pageSize,sort);

                //模糊查询
                ExampleMatcher matcher = ExampleMatcher.matching()
                        //名字 用包含的方式
                        .withMatcher("name", ExampleMatcher.GenericPropertyMatchers.contains())
                        .withIgnoreNullValues();

                Example<Student> example = Example.of(student, matcher);
                Page<Student> studentPage = studentService.getAll(example,pageable);
                return RUtil.success(studentPage.getContent(),studentPage.getTotalElements());

            }else {
                throw new RException(REnum.QUERY_ERR);
            }


        }
    }


}